AddressBase Premium data

Open Cadcorp SIS Address Loader; this will be your welcome screen.

  1. Select the folder containing the AddressBase Premium zipped (or unzipped) csv files.
  2. Select the folder to hold the log file and any unzipped data.
  3. Click Next.

Opt to load all address files or just a select few.

Data Model shows AddressBase or AddressBase Plus as appropriate.

The term Non geographic chunks or Geographic chunks (Tiles) will be displayed according to the type of data to be loaded.

  • Non-geographically chunked data does not have any reference to the geographic position of records.
  • For geographically chunked data the data files contain records in a 5km square. This is likely to result in there being a larger number of files than non-geographically chunked data. With geographically chunked data, the tables have to also store the tile name in every record to allow for tile replacement.

Click Next to select a database.

Note: The following screens relate to a PostGIS database.

Click Next and enter the relevant connection details.

TIP: When connecting to a Microsoft SQL Server database, you can also opt for a SQL Bulk Copy (initial supply only)

Click Next to see the AddressBase Premium Schema. The data will be loaded into the tables listed.

Option Description

Prefix table names with:

Enable this option to add a prefix to the table names shown in the list. Enter the prefix in the text box. (Remember the prefix must begin with a letter.)

Build interface table

Enable this option to build an Interface table. Click Options.

Enable Create concatenated LPI address fields tickbox if required. If left unticked, the Interface table will not be built at this stage.

NOTE: The Create an Interface table now - Create button will not be active at this stage. It will become available when data has been loaded and the command completed. Address Loader can then be run again to this step and the Create option will then be available. See Create an Interface table now below.

Create PAF gazetteer view

To create a Royal Mail Postcode Address File (PAF) check the tickbox and enter a name for the gazetteer.

Land Property Identifier (LPI)

To create a Land Property Identifier (LPI) check the tickbox and enter a name for the gazetteer.

Click Next and then Start to begin loading the data.

Two files were selected in this example so the progress of each file can be shown.

When data loading is complete, the addresses will be concatenated.

You will see a confirmation message when data load is complete.

Create an Interface table now

Run Address Loader and proceed to the Connect to database step.

The AddressBase Premium Schema dialog will be displayed:

There will now be additional options available on this dialog:

  1. Drop and rebuild indexes
  2. Truncate tables before load

Check the appropriate tickboxes if these options are required.

Click the Options button to display the Interface Table options dialog:

Click Create.

Click Yes on the confirmation screen.

The Interface table will now be created:

The process is complete when you see Interface table created.

Click Cancel to exit the wizard.